package cn.bdqn.smbms.dao;

import cn.bdqn.smbms.entity.Bill;
import cn.bdqn.smbms.entity.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface BillDao {

    //分页查询
    List<Bill> findByPage(
            @Param("queryProductName")
                    String queryProductName,
            @Param("queryProviderId")
                    Integer queryProviderId,
            @Param("isPayment")
                    Integer isPayment,
            @Param("from")
                    int from,
            @Param("pageSize")
                    int pageSize

    );

    //查询总记录数
    int getTotalCount(
            @Param("queryProductName")
                    String queryProductName,
            @Param("queryProviderId")
                    Integer queryProviderId,
            @Param("isPayment")
                    Integer isPayment
    );

    //根据id查询
    Bill findById(Integer id);

    //添加用户
    int addBill(Bill bill);

    //修改用户
    int updateBill(Bill bill);

    //删除
    int delBill(Integer id);


    Bill findByBillCode(String billCode);
}
